﻿CREATE TABLE [dbo].[Parliamentarians] (
    [CPALId]             INT            NOT NULL,
    [Title]              NVARCHAR (20)  NULL,
    [FirstName]          NVARCHAR (50)  NULL,
    [Surname]            NVARCHAR (50)  NULL,
    [Honorific]          NVARCHAR (50)  NULL,
    [Electorate]         NVARCHAR (50)  NULL,
    [State]              NVARCHAR (4)   NULL,
    [Chamber]            NVARCHAR (25)  NULL,
    [Telephone]          NVARCHAR (50)  NULL,
    [Fax]                NVARCHAR (50)  NULL,
    [EmailAddress]       NVARCHAR (100) NULL,
    [FacebookAddress]    NVARCHAR (100) NULL,
    [TwitterAddress]     NVARCHAR (100) NULL,
    [PersonalWebsite]    NVARCHAR (100) NULL,
    [PartyWebsite]       NVARCHAR (100) NULL,
    [MPID]               NVARCHAR (10)  NOT NULL,
    [FormerMember]       BIT            NOT NULL,
    [Gender]             NVARCHAR (MAX) NOT NULL,
    [PreferredName]      NVARCHAR (MAX) NULL,
    [PartyRecId]         INT            NOT NULL,
    [OtherNames]         NVARCHAR (MAX) NULL,
    [EmailVisible]       BIT            NULL,
    [ContactFormVisible] BIT            NULL,
    [Link1Address]       NVARCHAR (200) NULL,
    [Link2Address]       NVARCHAR (200) NULL,
    [Link3Address]       NVARCHAR (200) NULL,
    [Link4Address]       NVARCHAR (200) NULL,
    [Link5Address]       NVARCHAR (200) NULL,
    [Link1Label]         NVARCHAR (200) NULL,
    [Link2Label]         NVARCHAR (200) NULL,
    [Link3Label]         NVARCHAR (200) NULL,
    [Link4Label]         NVARCHAR (200) NULL,
    [Link5Label]         NVARCHAR (200) NULL,
    [ElectionMessage]    NVARCHAR (MAX) NULL,
    [FirstSpeechLink]    NVARCHAR (200) NULL,
    [ShortURL]           NVARCHAR (50)  NULL
);









